Hello. Is there a way for me to automatically put the quantity on the summary sheet based on the cell value? I tried to use the countif function in the summary sheet but it didn't work the way I wanted it to be. Thank you in advance.
Hello. Is there a way for me to automatically put the quantity on the summary sheet based on the cell value? I tried to use the countif function in the summary sheet but it didn't work the way I wanted it to be. Thank you in advance.
You should be more specific than just "did not work".
Do you want sumif than countif?
=SUMIF(MONDAY!$C$4:$C$7,$B4,MONDAY!$D$4:$D$7)
Or you need INDIRECT function to translate "MONDAY" into "sheet name" reference?
Quang PT
SUMMARY worksheet , C4 cell formula , Drag down and accross
HTML Code:
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks